FO_Providers

 

Field Type Notes

Provider_ID

int

ID field, a counter. Unique

Code

varchar(50)

Enter a unique code for the physician.

Name

varchar(255)

Name or description for the physician.

Number

varchar(50)

Default billing number for this physician.

Enter alphanumeric code as the billing number.

This number will override the account entry on the order screen.

Enter 'ASK' to make the system prompt for an account number when the physician is chosen on the order screen.

EntryGroupCode

varchar(50)

Entry group code for this physician.

Enter a valid group code.

Used to assign patients to this physician so user can search only for those patients during inquiry.

InquiryGroupCode

varchar(50)

Inquiry group code for this physician.

Enter a valid group code.

Used to assign patients to this physician so user can search only for those patients during inquiry.

Add1

varchar(80)

First address line.

Add2

varchar(80)

Second address line.

City

varchar(50)

City

St

varchar(50)

State

Zip

varchar(50)

Zip code

Tel

varchar(50)

Phone number

Fax

varchar(50)

Fax number

License

varchar(50)

License number for the physician.

Comments

varchar(50)

Notes related to the physician.

UPIN

varchar(50)

UPIN number

HID

varchar(50)

The LIS HID value.

Email

varchar(255)

Email address for this physician.

UserName

varchar(50)

User name associated with this physician.

CreateDate

datetime

Date record was created. Informational

EditDate

datetime

Date record was late created. Informational

Active

varchar(50)

Bit flag to indicate if this provider physician should be included in searches.

Enter 0 or 1

0 = not active, system will not find it in searches

1 = active, system will include in searches

FacilityID

varchar(50)

Default system facility ID for the physician.

LabPopup

varchar(255)

Message text to appear on the order screen when the provider is selectd by a lab user.

ClientPopup

varchar(255)

Message text to appear on the order screen when the provider is selectd by a client user.

AutoOrderTests

varchar(255)

A list of test codes to be ordered automatically when this provider is selected on the order screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test codes separated by pipes.

The rule fires when the first code is ordered.

ProvPerfLabGrp

varchar(50)

Represents a grouping code to be used in the performing lab assignment processing rule.

Allows for the grouping of physicians into groups so more generic rules can be written for performing lab assignments.

Mnemonic

varchar(50)

A code for which the system also searches pen performing a physician search on the order screen.

AutoOrderTestsCC

varchar(255)

A list of test codes to be ordered automatically when this provider is selected as a copy to on the order screen.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid test codes separated by pipes.

The rule fires when the first code is ordered.

PreventOrdersForINS

varchar(500)

A list of insurance codes used to drive a rule that does not allow the user to create any tests for this physician and any insurance codes in the list.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid insurance codes separated by pipes.

The rule fires when a test order is placed on the order screen.

A message is displayed warning that no orders can be entered.

NPI

varchar(50)

NPI value

LastName

varchar(80)

Last name of this physician provider.

FirstName

varchar(80)

First name of this physician provider.

MiddleName

varchar(80)

Middle name of this physician provider.

Title

varchar(50)

Title for this physician provider.

CellPhone

varchar(50)

Cell phone number

Pager

varchar(50)

Pager phone number

Tel2

varchar(50)

Additional phone number

Tel3

varchar(50)

Additional phone number

Country

varchar(50)

Country

AddressType

varchar(50)

Informational

Department

varchar(50)

Informational

Service

varchar(50)

Informational

Specialty

varchar(50)

Informational

LicenseState

varchar(50)

State where provider physician's license was issued.

Enter the standard two character state postal abbreviation.

DEA

varchar(50)

DEA code for provider physician.

RptTriggerSubscriptionID

varchar(50)

Used with RRE reporting tool.

Enter a valid subscription ID.

DoNotAllowAsOrdering

bit

Bit flag to indicate if this provider physician can be selected as ordering provider.

Enter 0 or 1

0 = do not allow selection

1 = allow selection

DoNotAllowAsCopyTo

bit

Bit flag to indicate if this provider physician can be selected as copy to provider.

Enter 0 or 1

0 = do not allow selection

1 = allow selection

LabCode

varchar(50)

Lab code used for this client.

Enter a valid lab code.

SourceSystem

varchar(50)

Default system/vendor/version ID for this provider.

Enter a valid ID.

Connects to the organization source system definitions.